CREATE TABLE [dbo].[DEMO] (
  [ID] varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
  [NAME] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [PASSWORD] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [NICK_NAME] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  CONSTRAINT [PK__DEMO__3214EC27BF799427] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[DEMO] SET (LOCK_ESCALATION = TABLE)